package cn.com.headfree.mouldshow.dao.impl;

import cn.com.headfree.entity.*;
import cn.com.headfree.entity.isc.User;
import cn.com.headfree.mouldshow.dao.HumanDataTempDao;
import com.gta.edu.sdk.base.dao.impl.BaseDaoImpl;
import com.gta.edu.sdk.common.dto.Page;
import com.gta.edu.sdk.util.StringUtil;

import org.apache.commons.lang.StringUtils;
import org.springframework.stereotype.Repository;

import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.*;

@Repository("/humanDataTempDao")
public class HumanDataTempDaoImpl extends BaseDaoImpl<TEmpBaseInfoTemp> implements HumanDataTempDao {

    /**
     * 基本信息临时数据
     * @param page
     */
    @Override
    public void getTEmpBaseInfoTempPageList(Page<TEmpBaseInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.sex,t.birth_date,t.nation,t.birth_place,t.politi_status,t.id_card_no,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_emp_base_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by create_time desc  ");
        this.findPageBySql(TEmpBaseInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //学历信息临时
    @Override
    public void getTEducateInfoTempPageList(Page<TEducateInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.start_time,t.end_time,t.educ_name,t.degree_name,t.grad_school,t.school_type,t.major,t.acqu_time,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_educate_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by create_time desc  ");
        this.findPageBySql(TEducateInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //工作经历临时
    @Override
    public void getTWorkExpInfoTempPageList(Page<TWorkExpInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.start_date,t.end_date,t.company,t.dept,t.post,t.rank,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_work_exp_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TWorkExpInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //教育培训及授课经历临时
    @Override
    public void getTContiStudyInfoTempPageList(Page<TContiStudyInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.start_time,t.end_time,t.major,t.study_place,t.type,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_conti_study_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TContiStudyInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //个人荣誉信息临时
    @Override
    public void getTHonorInfoTempPageList(Page<THonorInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.honor_title,t.award_org,t.honor_level,t.honor_type,t.acqu_time,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_honor_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(THonorInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //竞赛考试信息临时
    @Override
    public void getTContestInfoTempPageList(Page<TContestInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.comp_name,t.host_org,t.award_level,t.comp_rank,t.get_title,t.award_date,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_contest_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TContestInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //专家人才信息临时
    @Override
    public void getTExpertTitleInfoTempPageList(Page<TExpertTitleInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.major,t.level_name,t.emp_title,t.type,t.emp_term_start,t.emp_term_end,t.acqu_time,t.primitive_id,t.user_name,t.post_time ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_expert_title_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TExpertTitleInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //专业技术资格信息临时
    @Override
    public void getTProTecInfoTempPageList(Page<TProTecInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.subj_name,t.subj_set,t.subj_level,t.audit_org,t.org_level,t.cert_no,t.acqu_time,t.primitive_id,t.user_name,t.post_time ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_pro_tec_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TProTecInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //技能等级信息临时
    @Override
    public void getTSkillLevelInfoTempPageList(Page<TSkillLevelInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.tech_type,t.qualifi_level,t.audit_org,t.org_level,t.cert_no,t.acqu_time,t.primitive_id,t.user_name,t.post_time ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_skill_level_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TSkillLevelInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //导师带徒信息临时
    @Override
    public void getTSdtTutorPrentInfoTempPageList(Page<TSdtTutorPrentInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.start_date,t.end_date,t.primitive_id,t.user_name,GROUP_CONCAT(p.user_name) as prent_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_sdt_tutor_prent_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" left join t_sdt_prent_info_temp p on p.sdt_id = t.id");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" GROUP BY t.id ");
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TSdtTutorPrentInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //年度绩效临时
    @Override
    public void getTYearEffectInfoTempPageList(Page<TYearEffectInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.rate_year_start,t.rate_year_end,t.perfor_grade,t.resi_inte,t.cur_inte,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_year_effect_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TYearEffectInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //学术成果临时
    @Override
    public void getTAcadeAchiveInfoTempPageList(Page<TAcadeAchiveInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.acad_name,t.acad_type,t.pub_name,t.issn,t.periodic_no,t.publisher,t.level,t.pub_time,t.primitive_id,GROUP_CONCAT(p.erp_no order by p.rank) as erp_no,GROUP_CONCAT(p.user_name ORDER BY p.rank) as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_acade_achive_info_temp t ");
        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND p.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and p.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" GROUP BY t.id ");
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TAcadeAchiveInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //标准制定信息临时
    @Override
    public void getTStandInfoTempPageList(Page<TStandInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.name,t.type,t.level,t.issue_time,t.primitive_id,GROUP_CONCAT(p.erp_no order by p.rank) as erp_no,GROUP_CONCAT(p.user_name ORDER BY p.rank) as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_stand_info_temp t ");
        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND p.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and p.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" GROUP BY t.id ");
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TStandInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //专利信息临时
    @Override
    public void getTPatentInfoTempPageList(Page<TPatentInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.patent_name,t.patent_no,t.patent_type,t.apply_date,t.decl_date,t.primitive_id,GROUP_CONCAT(p.erp_no order by p.rank) as erp_no,GROUP_CONCAT(p.user_name ORDER BY p.rank) as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_patent_info_temp t ");
        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND p.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and p.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" GROUP BY t.id ");
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TPatentInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //技艺革新信息临时
    @Override
    public void getTTecInnovInfoTempPageList(Page<TTecInnovInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,award_type,t.achi_name,t.award_name,t.award_org,t.award_level,t.award_grade,t.group_name,t.award_date,t.primitive_id,GROUP_CONCAT(p.erp_no order by p.rank) as erp_no,GROUP_CONCAT(p.user_name ORDER BY p.rank) as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_tec_innov_info_temp t ");
        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND p.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and p.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" GROUP BY t.id ");
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TTecInnovInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //科技创新成果信息临时
    @Override
    public void getTTecManInnovTempPageList(Page<TTecManInnovTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.achi_name,t.award_name,t.award_org,t.award_level,t.award_grade,t.group_name,t.award_date,t.primitive_id,GROUP_CONCAT(p.erp_no order by p.rank) as erp_no,GROUP_CONCAT(p.user_name ORDER BY p.rank) as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_tec_man_innov_temp t ");
        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND p.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and p.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" GROUP BY t.id ");
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TTecManInnovTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }
    //项目课题成果信息临时
    @Override
    public void getTProjAchieveInfoTempPageList(Page<TProjAchieveInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.proj_name,t.start_date,t.end_date,t.proj_level,t.primitive_id,GROUP_CONCAT(p.erp_no order by p.rank) as erp_no,GROUP_CONCAT(p.user_name ORDER BY p.rank) as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_proj_achieve_info_temp t ");
        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND p.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and p.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
            sqlbuilder.append(" and t.org_id = ? ");
            arrayList.add(orgId);
//        }
        sqlbuilder.append(" GROUP BY t.id ");
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TProjAchieveInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }

    //员工流动临时
    @Override
    public void getTEmployeeMobilityTempPageList(Page<TEmployeeMobilityTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.flow_mode,t.flow_area,t.flow_type,t.begin_time,t.end_time,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_employee_mobility_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.fax");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TEmployeeMobilityTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }

    //挂职轮岗临时
    @Override
    public void getTRotationInfoTempPageList(Page<TRotationInfoTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.rotation_dept,t.rotation_org,t.rotation_post,t.start_time,t.end_time,t.primitive_id,t.user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_rotation_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TRotationInfoTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }

    //绩效积分临时
    @Override
    public void getTPerformanceScoreTempPageList(Page<TPerformanceScoreTemp> page,String userName,String erpNo,String orgId) {
        String sql = "";
        sql = "select t.id,t.erp_no,t.user_name,t.year,t.salary_grade,t.salary_level,t.perfor_grade,t.remain_point ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_performance_score_temp t ");
        sqlbuilder.append(" where 1=1 ");
        if(StringUtils.isNotBlank(userName)){
            sqlbuilder.append(" AND t.user_name LIKE CONCAT('%',?,'%') ESCAPE '/'");
            arrayList.add(userName);
        }
        if(StringUtils.isNotBlank(erpNo)){
            sqlbuilder.append(" and t.erp_no = ? ");
            arrayList.add(erpNo);
        }
//        if(StringUtils.isNotBlank(orgId)){
//        sqlbuilder.append(" and t.org_id = ? ");
//        arrayList.add(orgId);
//        }
        sqlbuilder.append(" order by t.create_time desc  ");
        this.findPageBySql(TPerformanceScoreTemp.class, sqlbuilder.toString(), page,arrayList.toArray());
    }

    /////////////////////////////////////////根据id获取单条数据///////////////////////////////
    /**
     * 基本信息临时数据
     * @param id
     */
    @Override
    public TEmpBaseInfoTemp getTEmpBaseInfoTempById(String id) {
        String sql = "";
//        sql = "select id,name as user_name,erp_no,sex,birth_date,nation,birth_place,politi_status,id_card_no ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_emp_base_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and id = ? ");
        return this.findUnique(TEmpBaseInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //学历信息临时
    @Override
    public TEducateInfoTemp getTEducateInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.start_time,t.end_time,t.educ_name,t.degree_name,t.grad_school,t.school_type,t.major,t.acqu_time,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_educate_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TEducateInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //工作经历临时
    @Override
    public TWorkExpInfoTemp getTWorkExpInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.start_date,t.end_date,t.company,t.dept,t.post,t.rank,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_work_exp_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TWorkExpInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //教育培训及授课经历临时
    @Override
    public TContiStudyInfoTemp getTContiStudyInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.start_time,t.end_time,t.major,t.study_place,t.type,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_conti_study_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TContiStudyInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //个人荣誉信息临时
    @Override
    public THonorInfoTemp getTHonorInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.honor_title,t.award_org,t.honor_level,t.honor_type,t.acqu_time,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_honor_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(THonorInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //竞赛考试信息临时
    @Override
    public TContestInfoTemp getTContestInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.comp_name,t.host_org,t.award_level,t.comp_rank,t.get_title,t.award_date,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_contest_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TContestInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //专家人才信息临时
    @Override
    public TExpertTitleInfoTemp getTExpertTitleInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.major,t.level_name,t.emp_title,t.type,t.emp_term_start,t.emp_term_end,t.acqu_time,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_expert_title_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TExpertTitleInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //专业技术资格信息临时
    @Override
    public TProTecInfoTemp getTProTecInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.subj_name,t.subj_set,t.subj_level,t.audit_org,t.org_level,t.cert_no,t.acqu_time,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_pro_tec_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TProTecInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //技能等级信息临时
    @Override
    public TSkillLevelInfoTemp getTSkillLevelInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.tech_type,t.qualifi_level,t.audit_org,t.org_level,t.cert_no,t.acqu_time,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_skill_level_info_temp t ");
//        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TSkillLevelInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //导师带徒信息临时
    @Override
    public TSdtTutorPrentInfoTemp getTSdtTutorPrentInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.prent_name,t.start_date,t.end_date,u.name as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_sdt_tutor_prent_info_temp t ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TSdtTutorPrentInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //年度绩效临时
    @Override
    public TYearEffectInfoTemp getTYearEffectInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.erp_no,t.rate_year_start,t.rate_year_end,t.perfor_grade,t.resi_inte,t.cur_inte,u.name as user_name ";
        sql = "select t.*,i.xb_name as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_year_effect_info_temp t ");
        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
//        sqlbuilder.append(" left join  isc_user u on t.erp_no = u.saphrid");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TYearEffectInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //学术成果临时
    @Override
    public TAcadeAchiveInfoTemp getTAcadeAchiveInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.acad_name,t.acad_type,t.pub_name,t.issn,t.periodic_no,t.publisher,t.level,t.pub_time,GROUP_CONCAT(u.NAME ORDER BY p.rank) as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_acade_achive_info_temp t ");
//        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.SAPHRID");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TAcadeAchiveInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //标准制定信息临时
    @Override
    public TStandInfoTemp getTStandInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.name,t.type,t.level,t.issue_time,GROUP_CONCAT(u.NAME ORDER BY p.rank) as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_stand_info_temp t ");
//        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.SAPHRID");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TStandInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //专利信息临时
    @Override
    public TPatentInfoTemp getTPatentInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.patent_name,t.patent_no,t.patent_type,t.apply_date,t.decl_date,GROUP_CONCAT(u.NAME ORDER BY p.rank) as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_patent_info_temp t ");
//        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.SAPHRID");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TPatentInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //技艺革新信息临时
    @Override
    public TTecInnovInfoTemp getTTecInnovInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.achi_name,t.award_name,t.award_org,t.award_level,t.award_grade,t.group_name,t.award_date,GROUP_CONCAT(u.NAME ORDER BY p.rank) as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_tec_innov_info_temp t ");
//        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.SAPHRID");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TTecInnovInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //科技创新成果信息临时
    @Override
    public TTecManInnovTemp getTTecManInnovTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.achi_name,t.award_name,t.award_org,t.award_level,t.award_grade,t.group_name,t.award_date,GROUP_CONCAT(u.NAME ORDER BY p.rank) as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_tec_man_innov_temp t ");
//        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.SAPHRID");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TTecManInnovTemp.class,sqlbuilder.toString(),new Object[]{id});
    }
    //项目课题成果信息临时
    @Override
    public TProjAchieveInfoTemp getTProjAchieveInfoTempById(String id) {
        String sql = "";
//        sql = "select t.id,t.proj_name,t.start_date,t.end_date,t.proj_level,GROUP_CONCAT(u.NAME ORDER BY p.rank) as user_name ";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_proj_achieve_info_temp t ");
//        sqlbuilder.append(" LEFT JOIN t_part_rank_temp p ON p.item_id = t.id");
//        sqlbuilder.append(" LEFT JOIN isc_user u on p.erp_no = u.SAPHRID");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TProjAchieveInfoTemp.class,sqlbuilder.toString(),new Object[]{id});
    }

    //员工流动信息临时
    @Override
    public TEmployeeMobilityTemp getTEmployeeMobilityTempById(String id){
        String sql = "";
        sql = "select t.*,i.xb_name as user_name ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_employee_mobility_temp t ");
        sqlbuilder.append(" left join t_isc_user_tmp i on t.erp_no = i.hr_erp ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TEmployeeMobilityTemp.class,sqlbuilder.toString(),new Object[]{id});
    }

    //员工流动信息临时
    @Override
    public TRotationInfoTemp getTRotationInfoTempById(String id) {
        String sql = "";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_rotation_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TRotationInfoTemp.class, sqlbuilder.toString(), new Object[]{id});
    }

    //绩效积分信息临时
    @Override
    public TPerformanceScoreTemp getTPerformanceScoreTempById(String id){
        String sql = "";
        sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_performance_score_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id = ? ");
        return this.findUnique(TPerformanceScoreTemp.class,sqlbuilder.toString(),new Object[]{id});
    }

    //////////////////////////////////////////////根据单位ID(org_id)获取数据/////////////////////////////////////////////////



    /**
     * 基本信息临时数据
     * @param id
     */
    @Override
    public List<TEmpBaseInfo> getTEmpBaseInfoTempByOrgId(String id) {
        String sql = "select * ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_emp_base_info_temp ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TEmpBaseInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //学历信息临时
    @Override
    public List<TEducateInfo> getTEducateInfoTempByOrgId(String id) {
        String sql = "select * ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_educate_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TEducateInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //工作经历临时
    @Override
    public List<TWorkExpInfo> getTWorkExpInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_work_exp_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TWorkExpInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //教育培训及授课经历临时
    @Override
    public List<TContiStudyInfo> getTContiStudyInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_conti_study_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TContiStudyInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //个人荣誉信息临时
    @Override
    public List<THonorInfo> getTHonorInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_honor_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(THonorInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //竞赛考试信息临时
    @Override
    public List<TContestInfo> getTContestInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_contest_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TContestInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //专家人才信息临时
    @Override
    public List<TExpertTitleInfo> getTExpertTitleInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_expert_title_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TExpertTitleInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //专业技术资格信息临时
    @Override
    public List<TProTecInfo> getTProTecInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_pro_tec_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TProTecInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //技能等级信息临时
    @Override
    public List<TSkillLevelInfo> getTSkillLevelInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_skill_level_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TSkillLevelInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //导师带徒信息临时
    @Override
    public List<TSdtTutorPrentInfo> getTSdtTutorPrentInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_sdt_tutor_prent_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TSdtTutorPrentInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    //徒弟信息临时
    @Override
    public List<TSdtPrentInfo> getTSdtPrentInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_sdt_prent_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TSdtPrentInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    //徒弟所获奖项信息临时
    @Override
    public List<TSdtAward> getTSdtAwardTempByOrgId(String orgId) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_sdt_award_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(orgId);
        return this.findAllBySQL(TSdtAward.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //年度绩效临时
    @Override
    public List<TYearEffectInfo> getTYearEffectInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_year_effect_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TYearEffectInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //学术成果临时
    @Override
    public List<TAcadeAchiveInfo> getTAcadeAchiveInfoTempByOrgId(String id) {
        String sql = "select t.* ,(select count(*) from t_part_rank_temp p where p.item_id = t.id) as part_count ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_acade_achive_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TAcadeAchiveInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //标准制定信息临时
    @Override
    public List<TStandInfo> getTStandInfoTempByOrgId(String id) {
        String sql = "select t.* ,(select count(*) from t_part_rank_temp p where p.item_id = t.id) as part_count ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_stand_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TStandInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //专利信息临时
    @Override
    public List<TPatentInfo> getTPatentInfoTempByOrgId(String id) {
        String sql = "select t.* ,(select count(*) from t_part_rank_temp p where p.item_id = t.id) as part_count ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_patent_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TPatentInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //技艺革新信息临时
    @Override
    public List<TTecInnovInfo> getTTecInnovInfoTempByOrgId(String id) {
        String sql = "select t.*  ,(select count(*) from t_part_rank_temp p where p.item_id = t.id) as part_count";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_tec_innov_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TTecInnovInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //科技创新成果信息临时
    @Override
    public List<TTecManInnov> getTTecManInnovTempByOrgId(String id) {
        String sql = "select t.* ,(select count(*) from t_part_rank_temp p where p.item_id = t.id) as part_count ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_tec_man_innov_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TTecManInnov.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }
    //项目课题成果信息临时
    @Override
    public List<TProjAchieveInfo> getTProjAchieveInfoTempByOrgId(String id) {
        String sql = "select t.* ,(select count(*) from t_part_rank_temp p where p.item_id = t.id) as part_count";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_proj_achieve_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TProjAchieveInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    //员工流动临时
    @Override
    public List<TEmployeeMobility> getTEmployeeMobilityTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_employee_mobility_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TEmployeeMobility.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    //挂职轮岗临时
    @Override
    public List<TRotationInfo> getTRotationInfoTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_rotation_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TRotationInfo.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    //绩效积分临时
    @Override
    public List<TPerformanceScoreTemp> getTPerformanceScoreTempByIds(String ids) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        sqlbuilder.append(" from t_performance_score_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.id in ('").append(ids).append("') ");
        return this.findAllBySQL(TPerformanceScoreTemp.class, sqlbuilder.toString(), null, false);
    }

    //参与人员信息临时
    @Override
    public List<TPartRank> getTPartRankTempByOrgId(String id) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_part_rank_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.org_id = ? ");
        arrayList.add(id);
        return this.findAllBySQL(TPartRank.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    /////////////////////////////////////////////////////根据条件删除临时库数据//////////////////////////////////////////////////////

    //基本信息
    @Override
    public void deleteTEmpBaseInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_emp_base_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //学历信息
    @Override
    public void deleteTEducateInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_educate_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //工作经历
    @Override
    public void deleteTWorkExpInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_work_exp_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //教育培训和授课经历
    @Override
    public void deleteTContiStudyInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_conti_study_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //个人荣誉
    @Override
    public void deleteTHonorInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_honor_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //竞赛考试
    @Override
    public void deleteTContestInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_contest_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //专家人才
    @Override
    public void deleteTExpertTitleInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_expert_title_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //专业技术资格
    @Override
    public void deleteTProTecInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_pro_tec_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //技能等级
    @Override
    public void deleteTSkillLevelInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_skill_level_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //导师带徒
    @Override
    public void deleteTSdtTutorPrentInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_sdt_tutor_prent_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //导师带徒徒弟信息
    @Override
    public void deleteTSdtPrentInfoTempByCondition(String orgId, String sdtId) {
        String sql = "delete from t_sdt_prent_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(sdtId)){
            sqlBuilder.append(" and sdt_id=#{sdtId,jdbcType=VARCHAR}");
            params.put("sdtId", sdtId);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //导师带徒徒弟所获奖项信息
    @Override
    public void deleteTSdtAwardTempByCondition(String orgId, String sdtTdId) {
        String sql = "delete from t_sdt_award_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(sdtTdId)){
            sqlBuilder.append(" and sdt_td_id=#{sdtTdId,jdbcType=VARCHAR}");
            params.put("sdtTdId", sdtTdId);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //年度绩效
    @Override
    public void deleteTYearEffectInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_year_effect_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //参与人员
    @Override
    public void deleteTPartRankTempByCondition(String orgId, String itemId) {
        String sql = "delete from t_part_rank_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(itemId)){
            sqlBuilder.append(" and item_id=#{itemId,jdbcType=VARCHAR}");
            params.put("itemId", itemId);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }


    //学术成果
    @Override
    public void deleteTAcadeAchiveInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_acade_achive_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //制度标准
    @Override
    public void deleteTStandInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_stand_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //专利信息
    @Override
    public void deleteTPatentInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_patent_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //技艺革新
    @Override
    public void deleteTTecInnovInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_tec_innov_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //科技创新
    @Override
    public void deleteTTecManInnovTempByCondition(String orgId, String id) {
        String sql = "delete from t_tec_man_innov_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //项目课题成果
    @Override
    public void deleteTProjAchieveInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_proj_achieve_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //员工流动
    @Override
    public void deleteTEmployeeMobilityTempByCondition(String orgId, String id) {
        String sql = "delete from t_employee_mobility_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //挂职轮岗
    @Override
    public void deleteTRotationInfoTempByCondition(String orgId, String id) {
        String sql = "delete from t_rotation_info_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //绩效积分
    @Override
    public void deleteTPerformanceScoreTempByCondition(String orgId, String id) {
        String sql = "delete from t_performance_score_temp ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" where 1=1 ");
        Map<String, Object> params = new HashMap<String, Object>();
        /*if(StringUtils.isNotBlank(orgId)){
            sqlBuilder.append(" and org_id=#{orgId,jdbcType=VARCHAR}");
            params.put("orgId",orgId);
        }*/
        if(StringUtils.isNotBlank(id)){
            sqlBuilder.append(" and ID=#{ID,jdbcType=VARCHAR}");
            params.put("ID", id);
        }
        this.executeSql(sqlBuilder.toString(), params);
    }

    //根据类型表ID获取参与人员信息
    @Override
    public List<TPartRankTemp> getTPartRankTempListByItemId(String itemId) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_part_rank_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.item_id = ? ");
        arrayList.add(itemId);
        return this.findAllBySQL(TPartRankTemp.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    //根据导师带徒表ID获取徒弟信息
    @Override
    public List<TSdtPrentInfoTemp> getTSdtPrentInfoTempListBySdtId(String sdtId) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_sdt_prent_info_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.sdt_id = ? ");
        arrayList.add(sdtId);
        return this.findAllBySQL(TSdtPrentInfoTemp.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    //根据导师带徒徒弟信息ID获取徒弟所获奖项
    @Override
    public List<TSdtAwardTemp> getTSdtAwardTempListBySdtTdId(String sdtTdId) {
        String sql = "select t.* ";
        StringBuilder sqlbuilder = new StringBuilder(sql);
        ArrayList<Object> arrayList = new ArrayList<Object>();
        sqlbuilder.append(" from t_sdt_award_temp t ");
        sqlbuilder.append(" where 1=1 ");
        sqlbuilder.append(" and t.sdt_td_id = ? ");
        arrayList.add(sdtTdId);
        return this.findAllBySQL(TSdtAwardTemp.class, sqlbuilder.toString(), null, false, arrayList.toArray());
    }

    /***************************根据id修改数据******************************************/

    @Override
    public void updateBaseInfoTempById(TEmpBaseInfoTemp tEmpBaseInfoTemp) {
        String sql = "UPDATE t_emp_base_info_temp  SET";
		StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append(" erp_no=#{erp_no,jdbcType=VARCHAR},");
        sqlBuilder.append(" name=#{name,jdbcType=VARCHAR},");
        sqlBuilder.append(" sex=#{sex,jdbcType=VARCHAR},");
        sqlBuilder.append(" birth_date=#{birth_date,jdbcType=DATE},");
        sqlBuilder.append(" nation=#{nation,jdbcType=VARCHAR},");
        sqlBuilder.append(" birth_place=#{birth_place,jdbcType=VARCHAR},");
        sqlBuilder.append(" born_place=#{born_place,jdbcType=VARCHAR},");
        sqlBuilder.append(" politi_status=#{politi_status,jdbcType=VARCHAR},");
        sqlBuilder.append(" id_card_no=#{id_card_no,jdbcType=VARCHAR},");
        sqlBuilder.append(" mobile_phone=#{mobile_phone,jdbcType=VARCHAR},");
        sqlBuilder.append(" level=#{level,jdbcType=VARCHAR},");
        sqlBuilder.append(" salary_grade=#{salary_grade,jdbcType=VARCHAR},");
        sqlBuilder.append(" party_date=#{party_date,jdbcType=DATE},");
        sqlBuilder.append(" job_date=#{job_date,jdbcType=DATE},");
        sqlBuilder.append(" unit=#{unit,jdbcType=VARCHAR},");
        sqlBuilder.append(" dept=#{dept,jdbcType=VARCHAR},");
        sqlBuilder.append(" cur_post=#{cur_post,jdbcType=VARCHAR} ");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
		Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tEmpBaseInfoTemp.getId());
		params.put("erp_no", tEmpBaseInfoTemp.getErpNo());
        params.put("name", tEmpBaseInfoTemp.getName());
        params.put("sex", tEmpBaseInfoTemp.getSex());
        params.put("birth_date", tEmpBaseInfoTemp.getBirthDate());
        params.put("nation", tEmpBaseInfoTemp.getNation());
        params.put("birth_place", tEmpBaseInfoTemp.getBirthPlace());
        params.put("born_place", tEmpBaseInfoTemp.getBornPlace());
        params.put("politi_status", tEmpBaseInfoTemp.getPolitiStatus());
        params.put("id_card_no", tEmpBaseInfoTemp.getIdCardNo());
        params.put("mobile_phone", tEmpBaseInfoTemp.getMobilePhone());
        params.put("level", tEmpBaseInfoTemp.getLevel());
        params.put("salary_grade", tEmpBaseInfoTemp.getSalaryGrade());
        params.put("party_date", tEmpBaseInfoTemp.getPartyDate());
        params.put("job_date", tEmpBaseInfoTemp.getJobDate());
        params.put("unit", tEmpBaseInfoTemp.getUnit());
        params.put("dept", tEmpBaseInfoTemp.getDept());
        params.put("cur_post", tEmpBaseInfoTemp.getCurPost());
		this.executeSql(sqlBuilder.toString(), params);
    }

    @Override
    public void updateTEducateInfoTempById(TEducateInfoTemp educateInfo) {
        String sql = "UPDATE t_educate_info_temp  SET ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        Map<String, Object> params = new HashMap<String, Object>();
        sqlBuilder.append(" start_time=#{start_time,jdbcType=VARCHAR},");
        sqlBuilder.append(" end_time=#{end_time,jdbcType=VARCHAR},");
        sqlBuilder.append(" acqu_time=#{acqu_time,jdbcType=DATE}, ");
        sqlBuilder.append(" grad_school=#{grad_school,jdbcType=DATE}, ");
        sqlBuilder.append(" school_type=#{school_type,jdbcType=INTEGER}, ");
        sqlBuilder.append(" major=#{major,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" educ_name=#{educ_name,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" degree_name=#{degree_name,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" is_cont_educ=#{is_cont_educ,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" is_employ_educ=#{is_cont_educ,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" is_highest_educ=#{is_cont_educ,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" user_name=#{user_name,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" id_card_no=#{id_card_no,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" updater_id=#{updater_id,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" updater_name=#{updater_name,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" update_time=#{update_time,jdbcType=DATE} ");
        sqlBuilder.append(" where id=#{id,jdbcType=VARCHAR} ");
        params.put("start_time", educateInfo.getStartTime());
        params.put("end_time", educateInfo.getEndTime());
        params.put("acqu_time", educateInfo.getAcquTime());
        params.put("grad_school", educateInfo.getGradSchool());
        params.put("school_type", educateInfo.getSchoolType());
        params.put("major", educateInfo.getMajor());
        params.put("educ_name", educateInfo.getEducName());
        params.put("degree_name", educateInfo.getDegreeName());
        params.put("is_cont_educ", educateInfo.getIsContEduc());
        params.put("is_employ_educ", educateInfo.getIsEmployEduc());
        params.put("is_highest_educ", educateInfo.getIsHighestEduc());
        params.put("user_name", educateInfo.getUserName());
        params.put("id_card_no", educateInfo.getIdCardNo());
        params.put("updater_id", educateInfo.getUpdaterId());
        params.put("updater_name", educateInfo.getUserName());
        params.put("update_time", new Timestamp(new Date().getTime()));
        params.put("id", educateInfo.getId());
        this.executeSql(sqlBuilder.toString(), params);
    }

    @Override
    public void updateTWorkExpInfoTempById(TWorkExpInfoTemp tWorkExpInfo) {
        String sql = "update t_work_exp_info_temp  set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        Map<String, Object> params = new HashMap<String, Object>();
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getUserName())){
            sqlBuilder.append("  user_name = #{user_name,jdbcType=VARCHAR},");
            params.put("user_name",tWorkExpInfo.getUserName());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getIdCardNo())){
            sqlBuilder.append("  id_card_no = #{id_card_no,jdbcType=VARCHAR},");
            params.put("id_card_no",tWorkExpInfo.getIdCardNo());
        }
        if(tWorkExpInfo.getStartDate()!=null){
            sqlBuilder.append("  start_date = #{start_date,jdbcType=DATE},");
            params.put("start_date",tWorkExpInfo.getStartDate());
        }
        if(tWorkExpInfo.getEndDate()!=null){
            sqlBuilder.append("  end_date = #{end_date,jdbcType=DATE},");
            params.put("end_date",tWorkExpInfo.getEndDate());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getCompany())){
            sqlBuilder.append("  company = #{company,jdbcType=VARCHAR},");
            params.put("company",tWorkExpInfo.getCompany());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getDept())){
            sqlBuilder.append("  dept = #{dept,jdbcType=VARCHAR},");
            params.put("dept",tWorkExpInfo.getDept());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getPost())){
            sqlBuilder.append("  post = #{post,jdbcType=VARCHAR},");
            params.put("post",tWorkExpInfo.getPost());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getRank())){
            sqlBuilder.append("  rank = #{rank,jdbcType=VARCHAR},");
            params.put("rank",tWorkExpInfo.getRank());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getJobContent())){
            sqlBuilder.append("  job_content = #{job_content,jdbcType=VARCHAR},");
            params.put("job_content",tWorkExpInfo.getJobContent());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getPostType())){
            sqlBuilder.append("  post_type = #{post_type,jdbcType=VARCHAR},");
            params.put("post_type",tWorkExpInfo.getPostType());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getUpdaterId())){
            sqlBuilder.append("  updater_id = #{updater_id,jdbcType=VARCHAR},");
            params.put("updater_id",tWorkExpInfo.getUpdaterId());
        }
        if(!StringUtil.isNullOrEmpty(tWorkExpInfo.getUpdaterName())){
            sqlBuilder.append("  updater_name = #{updater_name,jdbcType=VARCHAR},");
            params.put("updater_name",tWorkExpInfo.getUpdaterName());
        }
        sqlBuilder.append("  update_time = #{update_time,jdbcType=DATE} ");
        params.put("update_time",new Timestamp(new Date().getTime()));
        sqlBuilder = new StringBuilder(sqlBuilder.substring(0,sqlBuilder.length()-1));
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        params.put("id",tWorkExpInfo.getId());

        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTContiStudyInfoTempById(TContiStudyInfoTemp tContiStudyInfo) {
        String sql = "update t_conti_study_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder
                .append("start_time=#{start_time,jdbcType=VARCHAR},")
                .append("end_time=#{end_time,jdbcType=VARCHAR},")
                .append("major=#{major,jdbcType=VARCHAR},")
                .append("study_place=#{study_place,jdbcType=VARCHAR},")
                .append("certifier=#{certifier,jdbcType=VARCHAR},")
                .append("erp_no=#{erp_no,jdbcType=VARCHAR},")
                .append("user_name=#{user_name,jdbcType=VARCHAR},")
                .append("id_card_no=#{id_card_no,jdbcType=VARCHAR},")
                .append("type=#{type,jdbcType=VARCHAR},")
                .append("level=#{level,jdbcType=VARCHAR},")
                .append("study_length=#{study_length,jdbcType=INTEGER},")
                .append("creater_id=#{creater_id,jdbcType=VARCHAR},")
                .append("creater_name=#{creater_name,jdbcType=VARCHAR},")
                .append("create_time=#{create_time,jdbcType=DATE},")
                .append("updater_id=#{updater_id,jdbcType=VARCHAR},")
                .append("updater_name=#{updater_name,jdbcType=VARCHAR},")
                .append("update_time=now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tContiStudyInfo.getId());
        params.put("start_time", tContiStudyInfo.getStartTime());
        params.put("end_time", tContiStudyInfo.getEndTime());
        params.put("major", tContiStudyInfo.getMajor());
        params.put("study_place", tContiStudyInfo.getStudyPlace());
        params.put("certifier", tContiStudyInfo.getCertifier());
        params.put("erp_no", tContiStudyInfo.getErpNo());
        params.put("user_name", tContiStudyInfo.getUserName());
        params.put("id_card_no", tContiStudyInfo.getIdCardNo());
        params.put("type", tContiStudyInfo.getType());
        params.put("level", tContiStudyInfo.getLevel());
        params.put("study_length", tContiStudyInfo.getStudyLength());
        params.put("updater_id", tContiStudyInfo.getUpdaterId());
        params.put("updater_name", tContiStudyInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTHonorInfoTempById(THonorInfoTemp tHonorInfo) {
        String sql = "update  t_honor_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("user_name = #{user_name,jdbcType=VARCHAR},")
                .append("id_card_no = #{id_card_no,jdbcType=VARCHAR},")
                .append("acqu_time = #{acqu_time,jdbcType=VARCHAR},")
                .append("honor_title = #{honor_title,jdbcType=VARCHAR},")
                .append("award_org = #{award_org,jdbcType=VARCHAR},")
                .append("honor_level = #{honor_level,jdbcType=VARCHAR},")
                .append("honor_type = #{honor_type,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now() ");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tHonorInfo.getId());
        params.put("user_name", tHonorInfo.getUserName());
        params.put("id_card_no", tHonorInfo.getIdCardNo());
        params.put("acqu_time", tHonorInfo.getAcquTime());
        params.put("honor_title", tHonorInfo.getHonorTitle());
        params.put("award_org", tHonorInfo.getAwardOrg());
        params.put("honor_level", tHonorInfo.getHonorLevel());
        params.put("honor_type", tHonorInfo.getHonorType());
        params.put("updater_id", tHonorInfo.getUpdaterId());
        params.put("updater_name", tHonorInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTContestInfoTempById(TContestInfoTemp tContestInfo) {
        String sql = "update t_contest_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("user_name = #{user_name,jdbcType=VARCHAR},")
                .append("id_card_no = #{id_card_no,jdbcType=VARCHAR},")
                .append("award_date = #{award_date,jdbcType=DATE},")
                .append("comp_name = #{comp_name,jdbcType=VARCHAR},")
                .append("host_org = #{host_org,jdbcType=VARCHAR},")
                .append("award_name = #{award_name,jdbcType=VARCHAR},")
                .append("award_level = #{award_level,jdbcType=VARCHAR},")
                .append("comp_rank = #{comp_rank,jdbcType=VARCHAR},")
                .append("get_title = #{get_title,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now() ");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tContestInfo.getId());
        params.put("user_name", tContestInfo.getUserName());
        params.put("id_card_no", tContestInfo.getIdCardNo());
        params.put("award_date", tContestInfo.getAwardDate());
        params.put("comp_name", tContestInfo.getCompName());
        params.put("host_org", tContestInfo.getHostOrg());
        params.put("award_name", tContestInfo.getAwardName());
        params.put("award_level", tContestInfo.getAwardLevel());
        params.put("comp_rank", tContestInfo.getCompRank());
        params.put("get_title", tContestInfo.getGetTitle());
        params.put("updater_id", tContestInfo.getUpdaterId());
        params.put("updater_name", tContestInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTExpertTitleInfoTempById(TExpertTitleInfoTemp tExpertTitleInfo) {
        String sql = "update t_expert_title_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder
                .append("user_name=#{user_name,jdbcType=VARCHAR},")
                .append("id_card_no=#{id_card_no,jdbcType=VARCHAR},")
                .append("major=#{major,jdbcType=VARCHAR},")
                .append("acqu_time=#{acqu_time,jdbcType=VARCHAR},")
                .append("level_name=#{level_name,jdbcType=VARCHAR},")
                .append("type=#{type,jdbcType=VARCHAR},")
                .append("emp_term_start=#{emp_term_start,jdbcType=VARCHAR},")
                .append("emp_term_end=#{emp_term_end,jdbcType=VARCHAR},")
                .append("emp_title=#{emp_title,jdbcType=VARCHAR},")
                .append("updater_id=#{updater_id,jdbcType=VARCHAR},")
                .append("updater_name=#{updater_name,jdbcType=VARCHAR},")
                .append("update_time=now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tExpertTitleInfo.getId());
        params.put("user_name", tExpertTitleInfo.getUserName());
        params.put("id_card_no", tExpertTitleInfo.getIdCardNo());
        params.put("major", tExpertTitleInfo.getMajor());
        params.put("acqu_time", tExpertTitleInfo.getAcquTime());
        params.put("level_name", tExpertTitleInfo.getLevelName());
        params.put("type", tExpertTitleInfo.getType());
        params.put("emp_term_start", tExpertTitleInfo.getEmpTermStart());
        params.put("emp_term_end", tExpertTitleInfo.getEmpTermEnd());
        params.put("emp_title", tExpertTitleInfo.getEmpTitle());
        params.put("updater_id", tExpertTitleInfo.getUpdaterId());
        params.put("updater_name", tExpertTitleInfo.getUpdaterName());
        params.put("update_time", new Timestamp(new Date().getTime()));
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTProTecInfoTempById(TProTecInfoTemp tProTecInfo) {
        String sql = "update t_pro_tec_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder
                .append("user_name=#{user_name,jdbcType=VARCHAR},")
                .append("id_card_no=#{id_card_no,jdbcType=VARCHAR},")
                .append("acqu_time=#{acqu_time,jdbcType=VARCHAR},")
                .append("subj_name=#{subj_name,jdbcType=VARCHAR},")
                .append("subj_set=#{subj_set,jdbcType=VARCHAR},")
                .append("subj_level=#{subj_level,jdbcType=VARCHAR},")
                .append("audit_org=#{audit_org,jdbcType=VARCHAR},")
                .append("org_level=#{org_level,jdbcType=VARCHAR},")
                .append("cert_no=#{cert_no,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now() ");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tProTecInfo.getId());
        params.put("user_name", tProTecInfo.getUserName());
        params.put("id_card_no", tProTecInfo.getIdCardNo());
        params.put("acqu_time", tProTecInfo.getAcquTime());
        params.put("subj_name", tProTecInfo.getSubjName());
        params.put("subj_set", tProTecInfo.getSubjSet());
        params.put("subj_level", tProTecInfo.getSubjLevel());
        params.put("audit_org", tProTecInfo.getAuditOrg());
        params.put("org_level", tProTecInfo.getOrgLevel());
        params.put("cert_no", tProTecInfo.getCertNo());
        params.put("updater_id", tProTecInfo.getUpdaterId());
        params.put("updater_name", tProTecInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTSkillLevelInfoTempById(TSkillLevelInfoTemp tSkillLevelInfo) {
        String sql = "update t_skill_level_info_temp set  ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder
                .append("user_name = #{user_name,jdbcType=VARCHAR},")
                .append("id_card_no = #{id_card_no,jdbcType=VARCHAR},")
                .append("acqu_time = #{acqu_time,jdbcType=VARCHAR},")
                .append("tech_type = #{tech_type,jdbcType=VARCHAR},")
                .append("qualifi_level = #{qualifi_level,jdbcType=VARCHAR},")
                .append("audit_org = #{audit_org,jdbcType=VARCHAR},")
                .append("org_level = #{org_level,jdbcType=VARCHAR},")
                .append("cert_no = #{cert_no,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now() ");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tSkillLevelInfo.getId());
        params.put("user_name", tSkillLevelInfo.getUserName());
        params.put("id_card_no", tSkillLevelInfo.getIdCardNo());
        params.put("acqu_time", tSkillLevelInfo.getAcquTime());
        params.put("tech_type", tSkillLevelInfo.getTechType());
        params.put("qualifi_level", tSkillLevelInfo.getQualifiLevel());
        params.put("audit_org", tSkillLevelInfo.getAuditOrg());
        params.put("org_level", tSkillLevelInfo.getOrgLevel());
        params.put("cert_no", tSkillLevelInfo.getCertNo());
        params.put("updater_id", tSkillLevelInfo.getUpdaterId());
        params.put("updater_name", tSkillLevelInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTSdtTutorPrentInfoTempById(TSdtTutorPrentInfoTemp tSdtTutorPrentInfo) {
        String sql = "update t_sdt_tutor_prent_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("start_date = #{start_date,jdbcType=VARCHAR},")
                .append("end_date = #{end_date,jdbcType=VARCHAR},")
                .append("tutor_name = #{tutor_name,jdbcType=VARCHAR},")
                .append("prent_name = #{prent_name,jdbcType=VARCHAR},")
                .append("teach_summary = #{teach_summary,jdbcType=VARCHAR},")
                .append("id_card_no =#{id_card_no,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tSdtTutorPrentInfo.getId());
        params.put("start_date", tSdtTutorPrentInfo.getStartDate());
        params.put("end_date", tSdtTutorPrentInfo.getEndDate());
        params.put("tutor_name", tSdtTutorPrentInfo.getTutorName());
        params.put("prent_name", tSdtTutorPrentInfo.getPrentName());
        params.put("teach_summary", tSdtTutorPrentInfo.getTeachSummary());
        params.put("id_card_no", tSdtTutorPrentInfo.getIdCardNo());
        params.put("updater_id", tSdtTutorPrentInfo.getUpdaterId());
        params.put("updater_name", tSdtTutorPrentInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTYearEffectInfoTempById(TYearEffectInfoTemp yearEffectInfo) {
        String sql = "UPDATE t_year_effect_info_temp  SET ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        Map<String, Object> params = new HashMap<String, Object>();
        sqlBuilder.append(" user_name=#{user_name,jdbcType=VARCHAR},");
        sqlBuilder.append(" id_card_no=#{id_card_no,jdbcType=VARCHAR},");
        sqlBuilder.append(" rate_year_start=#{rate_year_start,jdbcType=DATE}, ");
        sqlBuilder.append(" rate_year_end=#{rate_year_end,jdbcType=DATE}, ");
        sqlBuilder.append(" rate_year=#{rate_year,jdbcType=INTEGER}, ");
        sqlBuilder.append(" perfor_grade=#{perfor_grade,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" resi_inte=#{resi_inte,jdbcType=DOUBLE}, ");
        sqlBuilder.append(" cur_inte=#{cur_inte,jdbcType=DOUBLE}, ");
        sqlBuilder.append(" updater_id=#{updater_id,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" updater_name=#{updater_name,jdbcType=VARCHAR}, ");
        sqlBuilder.append(" update_time=#{update_time,jdbcType=DATE} ");
        sqlBuilder.append(" where id=#{id,jdbcType=VARCHAR} ");
        params.put("user_name", yearEffectInfo.getUserName());
        params.put("id_card_no", yearEffectInfo.getIdCardNo());
        params.put("rate_year_start", yearEffectInfo.getRateYearStart());
        params.put("rate_year_end", yearEffectInfo.getRateYearEnd());
        params.put("rate_year", yearEffectInfo.getRateYear());
        params.put("perfor_grade", yearEffectInfo.getPerforGrade());
        params.put("resi_inte", yearEffectInfo.getResiInte());
        params.put("cur_inte", yearEffectInfo.getCurInte());
        params.put("updater_id", yearEffectInfo.getUpdaterId());
        params.put("updater_name", yearEffectInfo.getUserName());
        params.put("update_time", new Timestamp(new Date().getTime()));
        params.put("id", yearEffectInfo.getId());
        this.executeSql(sqlBuilder.toString(), params);
    }

    @Override
    public void updateTAcadeAchiveInfoTempById(TAcadeAchiveInfoTemp tAcadeAchiveInfo) {
        String sql = "update t_acade_achive_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("pub_time = #{pub_time,jdbcType=VARCHAR},")
                .append("acad_type = #{acad_type,jdbcType=VARCHAR},")
                .append("acad_name = #{acad_name,jdbcType=VARCHAR},")
                .append("summary = #{summary,jdbcType=VARCHAR},")
                .append("pub_name = #{pub_name,jdbcType=VARCHAR},")
                .append("issn = #{issn,jdbcType=VARCHAR},")
                .append("periodic_no = #{periodic_no,jdbcType=VARCHAR},")
                .append("page = #{page,jdbcType=VARCHAR},")
                .append("publisher = #{publisher,jdbcType=VARCHAR},")
                .append("level = #{level,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now() ");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tAcadeAchiveInfo.getId());
        params.put("pub_time", tAcadeAchiveInfo.getPubTime());
        params.put("acad_type", tAcadeAchiveInfo.getAcadType());
        params.put("acad_name", tAcadeAchiveInfo.getAcadName());
        params.put("summary", tAcadeAchiveInfo.getSummary());
        params.put("pub_name", tAcadeAchiveInfo.getPubName());
        params.put("issn", tAcadeAchiveInfo.getIssn());
        params.put("periodic_no", tAcadeAchiveInfo.getPeriodicNo());
        params.put("page", tAcadeAchiveInfo.getPage());
        params.put("publisher", tAcadeAchiveInfo.getPublisher());
        params.put("level", tAcadeAchiveInfo.getLevel());
        params.put("creater_id", tAcadeAchiveInfo.getCreaterId());
        params.put("creater_name", tAcadeAchiveInfo.getCreaterName());
        params.put("create_time", new Timestamp(new Date().getTime()));
        params.put("updater_id", tAcadeAchiveInfo.getUpdaterId());
        params.put("updater_name", tAcadeAchiveInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTStandInfoTempById(TStandInfoTemp tStandInfo) {
        String sql = "update t_stand_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("issue_time = #{issue_time,jdbcType=VARCHAR},")
                .append("name = #{name,jdbcType=VARCHAR},")
                .append("type = #{type,jdbcType=VARCHAR},")
                .append("level = #{level,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now() ");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tStandInfo.getId());
        params.put("issue_time", tStandInfo.getIssueTime());
        params.put("name", tStandInfo.getName());
        params.put("type", tStandInfo.getType());
        params.put("level", tStandInfo.getLevel());
        params.put("updater_id", tStandInfo.getUpdaterId());
        params.put("updater_name", tStandInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTPatentInfoTempById(TPatentInfoTemp tPatentInfo) {
        String sql = "update t_patent_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("patent_name = #{patent_name,jdbcType=VARCHAR},")
                .append("patent_no = #{patent_no,jdbcType=VARCHAR},")
                .append("patent_type = #{patent_type,jdbcType=VARCHAR},")
                .append("apply_date = #{apply_date,jdbcType=VARCHAR},")
                .append("decl_date = #{decl_date,jdbcType=VARCHAR},")
                .append("inventor = #{inventor,jdbcType=DATE},")
                .append("creater_id = #{creater_id,jdbcType=DATE},")
                .append("creater_name = #{creater_name,jdbcType=DATE},")
                .append("create_time = #{create_time,jdbcType=DATE},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tPatentInfo.getId());
        params.put("patent_name", tPatentInfo.getPatentName());
        params.put("patent_no", tPatentInfo.getPatentNo());
        params.put("patent_type", tPatentInfo.getPatentType());
        params.put("apply_date", tPatentInfo.getApplyDate());
        params.put("decl_date", tPatentInfo.getDeclDate());
        params.put("inventor", tPatentInfo.getInventor());
        params.put("updater_id", tPatentInfo.getUpdaterId());
        params.put("updater_name", tPatentInfo.getUpdaterName());
        params.put("update_time", new Timestamp(new Date().getTime()));
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTTecInnovInfoTempById(TTecInnovInfoTemp tTecInnovInfo) {
        String sql = "update t_tec_innov_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("award_type = #{award_type,jdbcType=VARCHAR},").append("achi_name = #{achi_name,jdbcType=VARCHAR},")
                .append("sumary = #{sumary,jdbcType=VARCHAR},")
                .append("award_name = #{award_name,jdbcType=VARCHAR},")
                .append("award_date = #{award_date,jdbcType=VARCHAR},")
                .append("award_org = #{award_org,jdbcType=VARCHAR},")
                .append("award_level = #{award_level,jdbcType=VARCHAR},")
                .append("award_grade = #{award_grade,jdbcType=VARCHAR},")
                .append("group_name = #{group_name,jdbcType=VARCHAR},")
                .append("member_name = #{member_name,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tTecInnovInfo.getId());
        params.put("award_type", tTecInnovInfo.getAwardType());
        params.put("achi_name", tTecInnovInfo.getAchiName());
        params.put("sumary", tTecInnovInfo.getSumary());
        params.put("award_name", tTecInnovInfo.getAwardName());
        params.put("award_date", tTecInnovInfo.getAwardDate());
        params.put("award_org", tTecInnovInfo.getAwardOrg());
        params.put("award_level", tTecInnovInfo.getAwardLevel());
        params.put("award_grade", tTecInnovInfo.getAwardGrade());
        params.put("group_name", tTecInnovInfo.getGroupName());
        params.put("member_name", tTecInnovInfo.getMemberName());
        params.put("updater_id", tTecInnovInfo.getUpdaterId());
        params.put("updater_name", tTecInnovInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTTecManInnovTempById(TTecManInnovTemp tTecManInnov) {
        String sql = "update t_tec_man_innov_temp set  ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("achi_name = #{achi_name,jdbcType=VARCHAR},")
                .append("achi_type = #{achi_type,jdbcType=VARCHAR},")
                .append("summary = #{summary,jdbcType=VARCHAR},")
                .append("award_name = #{award_name,jdbcType=VARCHAR},")
                .append("award_date = #{award_date,jdbcType=VARCHAR},")
                .append("award_org = #{award_org,jdbcType=VARCHAR},")
                .append("award_level = #{award_level,jdbcType=DATE},")
                .append("award_grade = #{award_grade,jdbcType=DATE},")
                .append("group_name = #{group_name,jdbcType=DATE},")
                .append("member_name = #{member_name,jdbcType=DATE},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tTecManInnov.getId());
        params.put("achi_name", tTecManInnov.getAchiName());
        params.put("achi_type", tTecManInnov.getAchiType());
        params.put("summary", tTecManInnov.getSummary());
        params.put("award_name", tTecManInnov.getAwardName());
        params.put("award_date", tTecManInnov.getAwardDate());
        params.put("award_org", tTecManInnov.getAwardOrg());
        params.put("award_level", tTecManInnov.getAwardLevel());
        params.put("award_grade", tTecManInnov.getAwardGrade());
        params.put("group_name", tTecManInnov.getGroupName());
        params.put("member_name", tTecManInnov.getMemberName());
        params.put("updater_id", tTecManInnov.getUpdaterId());
        params.put("updater_name", tTecManInnov.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTProjAchieveInfoTempById(TProjAchieveInfoTemp tProjAchieveInfo) {
        String sql = "update t_proj_achieve_info_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("start_date = #{start_date,jdbcType=VARCHAR},")
                .append("end_date = #{end_date,jdbcType=VARCHAR},")
                .append("proj_name = #{proj_name,jdbcType=VARCHAR},")
                .append("summary = #{summary,jdbcType=VARCHAR},")
                .append("proj_level = #{proj_level,jdbcType=VARCHAR},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tProjAchieveInfo.getId());
        params.put("start_date", tProjAchieveInfo.getStartDate());
        params.put("end_date", tProjAchieveInfo.getEndDate());
        params.put("proj_name", tProjAchieveInfo.getProjName());
        params.put("summary", tProjAchieveInfo.getSummary());
        params.put("proj_level", tProjAchieveInfo.getProjLevel());
        params.put("updater_id", tProjAchieveInfo.getUpdaterId());
        params.put("updater_name", tProjAchieveInfo.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }

    @Override
    public void updateTPerformanceScoreTempById(TPerformanceScoreTemp tPerformanceScoreTemp) {
        String sql = "update t_performance_score_temp set ";
        StringBuilder sqlBuilder = new StringBuilder(sql);
        sqlBuilder.append("salary_grade = #{salary_grade,jdbcType=VARCHAR},")
                .append("salary_level = #{salary_level,jdbcType=INTEGER},")
                .append("perfor_grade = #{perfor_grade,jdbcType=VARCHAR},")
                .append("remain_point = #{remain_point,jdbcType=DOUBLE},")
                .append("updater_id = #{updater_id,jdbcType=VARCHAR},")
                .append("updater_name = #{updater_name,jdbcType=VARCHAR},")
                .append("update_time = now()");
        sqlBuilder.append(" where 1=1 ");
        sqlBuilder.append(" and id = #{id,jdbcType=VARCHAR} ");
        Map<String, Object> params = new HashMap<String, Object>();
        params.put("id", tPerformanceScoreTemp.getId());
        params.put("salary_grade", tPerformanceScoreTemp.getSalaryGrade());
        params.put("salary_level", tPerformanceScoreTemp.getSalaryLevel());
        params.put("perfor_grade", tPerformanceScoreTemp.getPerforGrade());
        params.put("remain_point", tPerformanceScoreTemp.getRemainPoint());
        params.put("updater_id", tPerformanceScoreTemp.getUpdaterId());
        params.put("updater_name", tPerformanceScoreTemp.getUpdaterName());
        this.executeSql(sqlBuilder.toString(),params);
    }


}
